if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[vw_SubsidyTmpHavaleh]') and xtype='V')
Drop view [dbo].[vw_SubsidyTmpHavaleh]


IF EXISTS ( SELECT  *
            FROM    dbo.sysobjects
            WHERE   id = OBJECT_ID(N'[dbo].[Subsidy_InsertToTmpHavaleh_Over_Under]')
                    AND OBJECTPROPERTY(id, N'IsProcedure') = 1 )
    DROP PROCEDURE [dbo].[Subsidy_InsertToTmpHavaleh_Over_Under]

IF EXISTS ( SELECT  *
            FROM    dbo.sysobjects
            WHERE   id = OBJECT_ID(N'[dbo].[Subsidy_UpdateTmpHavaleh]')
                    AND OBJECTPROPERTY(id, N'IsProcedure') = 1 )
    DROP PROCEDURE [dbo].[Subsidy_UpdateTmpHavaleh]

IF EXISTS ( SELECT  *
            FROM    dbo.sysobjects
            WHERE   id = OBJECT_ID(N'[dbo].[SubsidyUpdateReverseCredit]')
                    AND OBJECTPROPERTY(id, N'IsProcedure') = 1 )
    DROP PROCEDURE [dbo].[SubsidyUpdateReverseCredit]

IF EXISTS ( SELECT  *
            FROM    dbo.sysobjects
            WHERE   id = OBJECT_ID(N'[dbo].[CalcIncrementalDeductionFactor]')
                    AND OBJECTPROPERTY(id, N'IsProcedure') = 1 )
    DROP PROCEDURE [dbo].[CalcIncrementalDeductionFactor]
